<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
        <button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length" @click="delTable">批量删除</button>
        <download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData" :type="exportExcel.type" :name="exportExcel.filename">
          <button class="uni-button" type="primary" size="mini">导出 Excel</button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" collection="opendb-admin-xtsetting" field="appname,WebUrl,APIjiekoUrl,About,ICPbeanhao,adminQQ,adminWX,adminAlipay,adminEmail,appUser_jieshao,app_iconImg_file,app_Web_appdownload,share_appSDK_type,share_title,share_imageUrl_file,share_summary,share_type,share_href,share_erweimUrl_file,App_Player_zyjx_jieko" :where="where" page-data="replace"
        :orderby="orderby" :getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
        v-slot:default="{data,pagination,loading,error,options}" :options="options" loadtime="manual" @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection" @selection-change="selectionChange">
          <uni-tr>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'appname')" sortable @sort-change="sortChange($event, 'appname')">软件名称</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'WebUrl')" sortable @sort-change="sortChange($event, 'WebUrl')">H5手机网站地址</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'APIjiekoUrl')" sortable @sort-change="sortChange($event, 'APIjiekoUrl')">API接口地址</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'About')" sortable @sort-change="sortChange($event, 'About')">关于我们</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'ICPbeanhao')" sortable @sort-change="sortChange($event, 'ICPbeanhao')">ICP备案号</uni-th>
            <uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'adminQQ')" sortable @sort-change="sortChange($event, 'adminQQ')">QQ号</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'adminWX')" sortable @sort-change="sortChange($event, 'adminWX')">微信号</uni-th>
            <uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'adminAlipay')" sortable @sort-change="sortChange($event, 'adminAlipay')">支付宝</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'adminEmail')" sortable @sort-change="sortChange($event, 'adminEmail')">Email邮箱</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'appUser_jieshao')" sortable @sort-change="sortChange($event, 'appUser_jieshao')">App介绍</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'app_iconImg_file')">app图标</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'app_Web_appdownload')" sortable @sort-change="sortChange($event, 'app_Web_appdownload')">app下载地址</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.share_appSDK_type_localdata" @filter-change="filterChange($event, 'share_appSDK_type')">分享调用SDK类型</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'share_title')" sortable @sort-change="sortChange($event, 'share_title')">分享内容的标题</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'share_imageUrl_file')">分享内容的图片</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'share_summary')" sortable @sort-change="sortChange($event, 'share_summary')">分享内容的摘要</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.share_type_localdata" @filter-change="filterChange($event, 'share_type')">分享类型</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'share_href')" sortable @sort-change="sortChange($event, 'share_href')">分享跳转链接</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'share_erweimUrl_file')">分享二维码</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'App_Player_zyjx_jieko')" sortable @sort-change="sortChange($event, 'App_Player_zyjx_jieko')">解析接口</uni-th>
            <uni-th align="center">操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item,index) in data" :key="index">
            <uni-td align="center">{{item.appname}}</uni-td>
            <uni-td align="center">{{item.WebUrl}}</uni-td>
            <uni-td align="center">{{item.APIjiekoUrl}}</uni-td>
            <uni-td align="center">{{item.About}}</uni-td>
            <uni-td align="center">{{item.ICPbeanhao}}</uni-td>
            <uni-td align="center">{{item.adminQQ}}</uni-td>
            <uni-td align="center">{{item.adminWX}}</uni-td>
            <uni-td align="center">{{item.adminAlipay}}</uni-td>
            <uni-td align="center">{{item.adminEmail}}</uni-td>
            <uni-td align="center">{{item.appUser_jieshao}}</uni-td>
            <uni-td align="center">
              <uni-file-picker v-if="item.app_iconImg_file && item.app_iconImg_file.fileType == 'image'" :value="item.app_iconImg_file" :file-mediatype="item.app_iconImg_file && item.app_iconImg_file.fileType" return-type="object" :imageStyles="imageStyles" readonly></uni-file-picker>
              <uni-link v-else :href="item.app_iconImg_file && item.app_iconImg_file.url" :text="item.app_iconImg_file && item.app_iconImg_file.url"></uni-link>
            </uni-td>
            <uni-td align="center">{{item.app_Web_appdownload}}</uni-td>
            <uni-td align="center">{{options.share_appSDK_type_valuetotext[item.share_appSDK_type]}}</uni-td>
            <uni-td align="center">{{item.share_title}}</uni-td>
            <uni-td align="center">
              <uni-file-picker v-if="item.share_imageUrl_file && item.share_imageUrl_file.fileType == 'image'" :value="item.share_imageUrl_file" :file-mediatype="item.share_imageUrl_file && item.share_imageUrl_file.fileType" return-type="object" :imageStyles="imageStyles" readonly></uni-file-picker>
              <uni-link v-else :href="item.share_imageUrl_file && item.share_imageUrl_file.url" :text="item.share_imageUrl_file && item.share_imageUrl_file.url"></uni-link>
            </uni-td>
            <uni-td align="center">{{item.share_summary}}</uni-td>
            <uni-td align="center">{{options.share_type_valuetotext[item.share_type]}}</uni-td>
            <uni-td align="center">{{item.share_href}}</uni-td>
            <uni-td align="center">
              <uni-file-picker v-if="item.share_erweimUrl_file && item.share_erweimUrl_file.fileType == 'image'" :value="item.share_erweimUrl_file" :file-mediatype="item.share_erweimUrl_file && item.share_erweimUrl_file.fileType" return-type="object" :imageStyles="imageStyles" readonly></uni-file-picker>
              <uni-link v-else :href="item.share_erweimUrl_file && item.share_erweimUrl_file.url" :text="item.share_erweimUrl_file && item.share_erweimUrl_file.url"></uni-link>
            </uni-td>
            <uni-td align="center">
              <textarea disabled="true" :value="item.App_Player_zyjx_jieko"></textarea>
            </uni-td>
            <uni-td align="center">
              <view class="uni-group">
                <button @click="navigateTo('./edit?id='+item._id, false)" class="uni-button" size="mini" type="primary">修改</button>
                <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count" @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
  </view>
</template>

<script>
  import { enumConverter, filterToWhere } from '../../js_sdk/validator/opendb-admin-xtsetting.js';

  const db = uniCloud.database()
  // 表查询配置
  const dbOrderBy = '' // 排序字段
  const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表
  // 分页配置
  const pageSize = 20
  const pageCurrent = 1

  const orderByMapping = {
    "ascending": "asc",
    "descending": "desc"
  }

  export default {
    data() {
      return {
        query: '',
        where: '',
        orderby: dbOrderBy,
        orderByFieldName: "",
        selectedIndexs: [],
        options: {
          pageSize,
          pageCurrent,
          filterData: {
            "share_appSDK_type_localdata": [
              {
                "text": "调用社交sdk分享,需在manifest.json的sdk配置中配的分享sdk厂商，与本机安装了什么社交App无关",
                "value": 1
              },
              {
                "text": "调用系统分享组件发送分享消息，不需要配置分享SDK",
                "value": 2
              }
            ],
            "share_type_localdata": [
              {
                "text": "图文",
                "value": 1
              },
              {
                "text": "纯文字",
                "value": 2
              },
              {
                "text": "纯图片",
                "value": 3
              }
            ]
          },
          ...enumConverter
        },
        imageStyles: {
          width: 64,
          height: 64
        },
        exportExcel: {
          "filename": "opendb-admin-xtsetting.xls",
          "type": "xls",
          "fields": {
            "软件名称": "appname",
            "H5手机网站地址": "WebUrl",
            "API接口地址": "APIjiekoUrl",
            "关于我们": "About",
            "ICP备案号": "ICPbeanhao",
            "QQ号": "adminQQ",
            "微信号": "adminWX",
            "支付宝": "adminAlipay",
            "Email邮箱": "adminEmail",
            "App介绍": "appUser_jieshao",
            "app图标": "app_iconImg_file",
            "app下载地址": "app_Web_appdownload",
            "分享调用SDK类型": "share_appSDK_type",
            "分享内容的标题": "share_title",
            "分享内容的图片": "share_imageUrl_file",
            "分享内容的摘要": "share_summary",
            "分享类型": "share_type",
            "分享跳转链接": "share_href",
            "分享二维码": "share_erweimUrl_file",
            "解析接口": "App_Player_zyjx_jieko"
          }
        },
        exportExcelData: []
      }
    },
    onLoad() {
      this._filter = {}
    },
    onReady() {
      this.$refs.udb.loadData()
    },
    methods: {
      onqueryload(data) {
        this.exportExcelData = data
      },
      getWhere() {
        const query = this.query.trim()
        if (!query) {
          return ''
        }
        const queryRe = new RegExp(query, 'i')
        return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
      },
      search() {
        const newWhere = this.getWhere()
        this.where = newWhere
        this.$nextTick(() => {
          this.loadData()
        })
      },
      loadData(clear = true) {
        this.$refs.udb.loadData({
          clear
        })
      },
      onPageChanged(e) {
        this.selectedIndexs.length = 0
        this.$refs.table.clearSelection()
        this.$refs.udb.loadData({
          current: e.current
        })
      },
      navigateTo(url, clear) {
        // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
        uni.navigateTo({
          url,
          events: {
            refreshData: () => {
              this.loadData(clear)
            }
          }
        })
      },
      // 多选处理
      selectedItems() {
        var dataList = this.$refs.udb.dataList
        return this.selectedIndexs.map(i => dataList[i]._id)
      },
      // 批量删除
      delTable() {
        this.$refs.udb.remove(this.selectedItems(), {
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      // 多选
      selectionChange(e) {
        this.selectedIndexs = e.detail.index
      },
      confirmDelete(id) {
        this.$refs.udb.remove(id, {
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      sortChange(e, name) {
        this.orderByFieldName = name;
        if (e.order) {
          this.orderby = name + ' ' + orderByMapping[e.order]
        } else {
          this.orderby = ''
        }
        this.$refs.table.clearSelection()
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      },
      filterChange(e, name) {
        this._filter[name] = {
          type: e.filterType,
          value: e.filter
        }
        let newWhere = filterToWhere(this._filter, db.command)
        if (Object.keys(newWhere).length) {
          this.where = newWhere
        } else {
          this.where = ''
        }
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      }
    }
  }
</script>

<style>
</style>
